﻿
if not exists(select name from sysobjects where name = 'ERPStoreOffersOffer' and xtype = 'U')
Begin

	Create table dbo.ERPStoreOffersOffer (
		Id int identity(1,1) not null
		, ProductSelectionId int not null
		, Name varchar(50) not null
		, StartDate datetime null
		, EndDate datetime null
		, Description nvarchar(max) null
		, Title varchar(1024) not null
		, CSSTag varchar(20) null
		, ViewName varchar(50) null
		, Link varchar(255) not null
	)

	alter table dbo.ERPStoreOffersOffer add constraint PK_ERPStoreOffersOffer_Id primary key (id)

End
Go